How to Get Online 1996 Spring/HOW2GON.ISO/mac/Desktop Folder/How To Get Online/SERVERS/CGI/examples/sybform.sql

Text File | 1996-03-01 | 1.9 KB | 1 lines | [TEXT/ttxt]

<sql valarg 1>RANGE=0123456789-</sql><sql init>SYBASE=/home1/sybase</sql><sql connect conn1>SERVER=SYBASEUSER=saPASS=</sql><sql execute conn1>set textsize 65536</sql><FORM ACTION="fillrec.sql?%{%1a%}", METHOD=POST><sql format>Author ID "%1a"<TITLE>Update Author Information (%1d %2d)</TITLE><TABLE WIDTH=2,CELLPADDING=20,CELLSPACING=2,BORDER=5><TR><TH BASELINE ALIGN=RIGHT>First Name</TH><TD><INPUT TYPE="text" NAME="FNAME" VALUE="%1d"><TR><TH BASELINE ALIGN=RIGHT>Last Name</TH><TD><INPUT TYPE="text" NAME="LNAME" VALUE="%2d"><TR><TH BASELINE ALIGN=RIGHT>Phone</TH><TD><INPUT TYPE="text" NAME="PHONE" VALUE="%3d"><TR><TH BASELINE ALIGN=RIGHT>Address</TH><TD><INPUT TYPE="text" NAME="ADDRESS" VALUE="%4d"><TR><TH BASELINE ALIGN=RIGHT>City</TH><TD><INPUT TYPE="text" NAME="CITY" VALUE="%5d"><TR><TH BASELINE ALIGN=RIGHT>State</TH><TD><INPUT TYPE="text" NAME="STATE" VALUE="%6d"><TR><TH BASELINE ALIGN=RIGHT>Postcode</TH><TD><INPUT TYPE="text" NAME="PCODE" VALUE="%7d"></TABLE></sql><sql query conn1>select    au_fname,    au_lname,    phone,    address,    city,    state,    zipfrom    pubs..authorswhere    au_id = '%1a'</sql><BR><INPUT TYPE="submit" VALUE="Update"><INPUT TYPE="reset" VALUE="Cancel"></FORM><HR><sql format><A HREF="sybform.sql?%{%1d%}">Next author</A> (%2d %3d)<BR></sql><sql query conn1>select au_id, au_fname, au_lname from pubs..authors whereau_id = (select min(au_id) from pubs..authors where au_id > '%1a')</sql><sql format><A HREF="sybform.sql?%{%1d%}">Previous author</A> (%2d %3d)<BR></sql><sql query conn1>select au_id, au_fname, au_lname from pubs..authors whereau_id = (select max(au_id) from pubs..authors where au_id < '%1a')</sql><HR><FORM ACTION="sybform.sql", METHOD=GET><INPUT TYPE="submit" VALUE="Switch To"><SELECT NAME="isindex", SIZE=1><sql format><OPTION>%1d %3d, %2d</sql><sql query conn1>select au_id, au_fname, au_lname from pubs..authors order by au_lname, au_fname</sql></SELECT></FORM><sql disconnect conn1></sql><sql uninit></sql>